# 1.导入pandas模块
import pandas as pd

# 2.把Excel文件中的数据读入pandas
# df = pd.read_excel("/Users/daydaisy/Downloads/test.xlsx")
# print(df)
# 3.读取excel的某一个sheet
img_url="http://srv-prod-ch/DataAutoreverse/dataarcn1/2022_02281/Big/2281_01393_01_01_0jsc.jpg"
df = pd.read_excel('car02.xlsx', sheet_name='Sheet1')
# df = pd.read_excel('car01.xls', sheet_name='Sheet1')
print(df)
print(df.values)

# 4.获取列标题
print(df.columns)
# 5.获取列行标题
print(df.index)
# 6.制定打印某一列
print(df["Location"])
# 7.描述数据
print(df.describe())